package com.xgl.pojo;

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.excel.annotation.ExcelEntity;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;
import java.time.LocalDate;
import java.time.LocalDateTime;

/**
 * <p>
 * 学生个人信息
 * </p>
 *
 * @author 最最帅气的熊国林
 * @since 2021-05-15
 */
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("s_studentinfo")
@ApiModel(value="Studentinfo对象", description="学生个人信息")
public class Studentinfo implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "ID")
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty(value = "学号")
    @Excel(name = "学号")
    private String s_number;

    @ApiModelProperty(value = "姓名")
    @Excel(name = "姓名")
    private String name;

    @ApiModelProperty(value = "英文名")
    @Excel(name = "英文名")
    private String e_name;

    @ApiModelProperty(value = "民族id")
    private Integer nationId;

    @ApiModelProperty(value = "性别")
    @Excel(name = "性别")
    private String sex;

    //id对应实质
    @ApiModelProperty(value = "民族")
    @TableField(exist = false)
    @ExcelEntity(name = "民族")
    private Nation nation;

    @ApiModelProperty(value = "学院")
    @TableField(exist = false)
    @ExcelEntity(name = "学院")
    private Department department;

    @ApiModelProperty(value = "专业")
    @TableField(exist = false)
    @ExcelEntity(name = "专业")
    private Major major;

    @ApiModelProperty(value = "所在年级")
    @Excel(name = "所在年级")
    private String grade;

    @ApiModelProperty(value = "学制(在校时间)")
    @Excel(name = "学制")
    private Integer s_year;

    @ApiModelProperty(value = "项目")
    @Excel(name = "项目")
    private String s_type;

    @ApiModelProperty(value = "学历层次(本 = 1/专 = 0/硕 = 2/博 = 3)")
    @Excel(name = "学历层次")
    private String s_level;

    @ApiModelProperty(value = "学生类别(本 = 1/专 = 0/硕 = 2/博 = 3)")
    @Excel(name = "学生类别")
    private String s_category;

    @ApiModelProperty(value = "院系id")
    private Integer departmentId;

    @ApiModelProperty(value = "专业id")
    private Integer majorId;

    @ApiModelProperty(value = "入校时间")
    @JsonFormat(pattern = "yyyy-MM-dd",timezone = "Asia/Shanghai")
    @Excel(name = "入校时间",format = "yyyy-MM-dd",width = 20)
    private LocalDate create_time;

    @ApiModelProperty(value = "应毕业时间")
    @JsonFormat(pattern = "yyyy-MM-dd",timezone = "Asia/Shanghai")
    @Excel(name = "毕业时间",format = "yyyy-MM-dd",width = 20)
    private LocalDate graduation_time;

    @ApiModelProperty(value = "行政管理院系(跟院系一样)")
    @Excel(name = "行政管理院系")
    private String admin_department;

    @ApiModelProperty(value = "学习形式(普通全日 = 1/普通半日= 0/其他=2)")
    @Excel(name = "学习形式")
    private String learn_form;

    @ApiModelProperty(value = "学籍状态(1=在校，2=休学，3=离校，4=注册)")
    @Excel(name = "学籍状态")
    private String statue;

    @ApiModelProperty(value = "是否在籍")
    @Excel(name = "是否在籍")
    private String is_living;

    @ApiModelProperty(value = "是否在校")
    @Excel(name = "是否在校")
    private String is_leaving;

    @ApiModelProperty(value = "行政班级")
    @Excel(name = "行政班级")
    private String admin_class;

    @ApiModelProperty(value = "所属校区（1=大学城/2=尖顶坡）")
    @Excel(name = "所属校区")
    private String school_area;

    @ApiModelProperty(value = "上一个学生信息的hashcode")
    private String previousHash;

    @ApiModelProperty(value = "删除标志")
    private Integer is_delete;

    @ApiModelProperty(value = "Hash代码")
    @Excel(name = "Hash代码")
    private String hash_code;





}
